/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.merashehar.contants;

/**
 *
 * @author binkam
 */
public interface MerasheharContants {
    public static final String findAllCategories ="select * from category order by category_name asc";
    //public static final String findAllCategories ="SELECT * FROM   category  LEFT OUTER JOIN subcategory ON category.category_id = subcategory.category_id order by category.category_name, subcategory.subcategory_name;";
    public static final String findSubCategoryForCategory ="select * from subcategory where category_id= ? order by subcategory_name asc";
    public static final String findAllCities ="select * from city order by city_name asc";
    public static final String findItemsForSubCategoryOfCity ="select i.infoitem_id, i.item_name, i.item_description, i.item_image_url, i.item_rank, a.address_line1, a.address_line2, a.phone1, a.phone2, a.mobile, a.zip, a.landmark1, a.landmark2 from infoitem i, subcategory s, city c, address a where i.subcategory_id = s.subcategory_id and i.address_id = a.address_id and i.city_id = c.city_id and c.city_id=$C$ and s.subcategory_id = $S$";
    
}
